home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 8 / developer source - volume 8.iso / orinf / feb97 / aronf108.gif < prev    next >
Graphics Interchange Format  |  1997-06-27  |  32.5 KB  |  354x316  |  4-bit (16 colors)
   ocr: - * select/*+ rule V companyrame from company, saes where oumpany, compenya = sees.compeny.id and sales. parios_ id=3 and Gees.sales_ total > 1000 Exucute Print Explain Hele: User. scott Close: SonctStetomont: NestedLoops F9 Escoi 1 a 1 deesaze, % sut TableAcoos ByRoud Soosicompany RONS 359Tetlespece:users Chique indexunique Scan Sc0L.compeny_PK (Compervyid) a cisuno Keys: 358Rons Ferikoy Tabiespace/Users Figure 8: A sample SELECT statement and the accompanying explain plan, showing NESTED LOOPS.